SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801036 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801036 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193751,374671,400840,160358,249661,379498,738123,284865,712258,220528,682074,223625,224889,868930,768004,740201,892211,477943,693969,165622,593870,474894,59300,995839,647335,52210,46759,223389,600342,613187,1047037,495305,396436,921112,759704,1022045,60196,959749,782868,909740,832504,307195,427564,1024580,828220,618760,222762,312291,787897,497584,508105,999186,485898,265205,723768,905769,887355,179950,1584,106411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]