SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402804 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402804 [ RunTime:0.003163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732115,460013,785941,520769,855061,805840,656088,97931,686372,1005291,813171,946108,1028132,671987,67179,281081,114180,855693,474105,138810,979528,798771,32580,35866,122324,300398,655612,379253,248279,145793,117260,969713,36269,4505,604540,132881,882175,27289,142259,538201,207899,730858,233205,1025146,105753,447793,768775,791660,675869,197817,470847,461636,860298,698124,633009,84050,457418,50051,518117,544079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]