SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49742 LIMIT 1 [ RunTime:0.000742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49742 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597244,361881,1032530,983887,610629,1032958,397394,1004877,861326,471933,584790,740043,778672,254687,1047655,558489,634587,100918,249557,234624,847034,847817,828572,982939,54442,738718,357832,933674,64997,604827,127712,944484,728301,292986,552900,491665,520913,421716,307196,161089,187857,981876,350192,654158,577976,428399,1047469,521053,789559,720134,594738,965838,530773,465669,252890,965263,933109,893260,592560,618372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]