SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416601 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416601 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016160,827729,872253,511056,10739,789010,520374,189153,491579,727808,854355,174548,472785,39574,364115,460548,206822,1016566,26198,659439,742757,257202,139673,615776,747258,362236,74456,39631,685570,794652,206740,19864,584322,53832,63185,876961,962480,492163,949363,882872,942617,112297,457590,970562,774461,784732,927576,534922,361321,569231,451923,18870,273195,484463,738870,856359,934262,114506,8911,569561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]