SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335713 LIMIT 1 [ RunTime:0.001136s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335713 [ RunTime:0.002756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765401,659083,145009,927540,331863,174090,979070,823692,807217,298051,926237,26673,1035610,1000331,519032,254983,317671,578542,439702,955885,537557,547089,643457,98275,952934,1000566,353699,866215,48882,285628,879745,890256,223925,985337,734086,270540,581116,552282,345430,689098,195371,243113,702110,119054,894758,619172,960976,485871,1025863,190920,11001,467942,272083,25880,549206,1024298,624035,723366,635902,932232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]