SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545034 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545034 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021166,5909,270297,243952,169777,634621,329348,942910,233538,10813,408460,314048,858080,191158,145814,958822,646973,402299,72602,288973,234232,343907,73128,74558,824033,378858,105584,949654,520445,796762,1020436,785717,124925,255601,540587,179072,98955,467085,659025,1046140,466100,245616,869985,105859,837652,344541,790188,77510,440905,1024863,164181,342489,823520,283626,418069,42254,471668,106672,68015,814856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001524s ]