SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001645s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404067 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404067 [ RunTime:0.004107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185932,222598,539402,970173,767818,376334,608039,271592,192915,1025673,841329,809387,343480,1027936,934692,980181,470018,881270,229002,1047963,99769,32457,655232,476545,181369,210447,438305,214550,405647,211541,262654,334967,857354,50881,871325,357718,683629,994666,255739,531963,324320,933735,622656,478064,693473,554603,146605,57773,193219,559327,1004334,20754,789022,46893,770776,75014,540474,1034842,810268,981068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]