SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 177414 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 177414 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176197,455630,275542,907490,282002,100440,109949,802862,45194,91991,886571,427159,734720,794472,885844,811831,374571,133537,782521,36569,172172,434420,508403,79537,135765,767185,773822,509076,542278,988106,729091,923061,347435,389022,739070,93900,961785,477201,121874,759513,385442,33197,960014,125290,492006,868905,530889,854967,1003638,832454,727750,460002,501433,415360,845520,1030772,539954,403276,407704,167811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 177414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 177414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]