SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412828 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412828 [ RunTime:0.004109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969422,212999,878040,1041504,557192,529063,691863,893748,826421,1019038,402921,496896,1027026,48246,229535,353588,749428,318188,700760,600745,194179,117289,986192,690511,331211,165683,202126,999940,332237,143,279472,931010,562464,120180,358994,778735,708502,231529,326223,263433,641136,547209,586362,808472,902999,277404,984864,236381,243945,402558,781796,554523,969037,443200,871531,8322,136774,323919,249312,878987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]