SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98449 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98449 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177309,969031,951997,320489,665266,99091,633572,820719,597104,1048398,169236,495055,1035342,765573,141574,920047,984774,219390,487443,714852,722602,338255,24054,398705,434448,578007,603738,949092,433796,658277,20889,187190,2986,187662,420521,242689,26377,979157,75794,963246,834955,287297,865581,368616,282054,752167,762670,927967,337782,987631,164933,526350,607886,479609,85100,332165,249645,798132,121306,400658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]