SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961809 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961809 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953797,934194,165029,940399,222135,1017254,495886,720603,353839,290598,823663,222986,187778,91896,202204,864155,114999,462188,907941,101651,527917,133424,627354,988811,301311,968168,467119,311561,649854,688556,394787,746103,433154,411793,801754,150808,323115,1009292,738406,341824,1046629,855467,435263,430449,912150,931937,257057,881288,152329,577033,83575,148258,530271,812206,796115,2577,159949,789802,696354,987497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]