SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195015 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195015 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425349,923368,75628,679303,694388,610049,762011,509518,748913,1043163,282377,1044546,475101,320929,934136,1003044,173084,768567,223244,504685,811295,268454,659295,180489,673462,933912,226890,90790,13488,348150,667286,565748,585897,98213,936612,31245,333844,757111,231377,199531,5876,729051,102635,356265,146312,456492,384687,382326,636883,43086,597589,979355,1015427,440841,883529,947385,584119,1025207,720640,753435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]