SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409976 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409976 [ RunTime:0.001452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41235,863763,949492,572904,75035,903923,271132,461751,679832,159630,781127,886990,383655,279708,481721,793365,690368,858724,988217,724237,688377,178403,173988,480194,516259,424247,561648,551240,1048763,930412,70241,615659,50282,708406,848470,854891,569543,305621,597272,463175,755371,20526,636910,428787,206919,959818,201700,325533,972415,83513,98353,490048,397868,20004,10794,975096,668730,702934,448994,676166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]