SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424866 LIMIT 1 [ RunTime:0.002260s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424866 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39524,49802,558472,762625,945081,8845,566111,1032469,631923,406278,678633,206108,505493,83514,240056,955661,528000,420095,298344,805486,275297,877208,889218,445875,1030299,755431,45700,76396,294100,742790,377278,574222,144564,198975,853097,345986,958575,944348,227563,472643,580974,494300,950038,1014149,164215,373392,1022357,882919,728008,140927,354497,83597,91257,130089,134136,659136,516468,265190,850851,90054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424866 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424866 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]