SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002843s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3668 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3668 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759330,108699,181999,514696,398437,747217,782120,200231,876037,3613,613867,662237,678104,36040,866419,102725,425615,128932,913658,501573,872344,855802,161291,588074,999731,928112,1018883,1027103,608570,136471,875158,858610,647184,454460,66926,600277,1039582,653424,791301,789309,883443,379319,294893,252712,922083,198180,681307,964105,562416,293597,202082,715263,490064,881597,205701,390940,367282,282650,706600,437297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]