SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398910 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398910 [ RunTime:0.005458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477218,420126,394537,1014501,470764,476179,971126,976033,582214,724121,974154,351376,250870,371657,128102,760816,626851,817871,338123,527824,217826,283945,979782,252092,294702,968924,924114,503602,537180,943214,745074,229073,274107,986192,1375,526979,186888,564990,840408,274287,961553,720184,908869,335234,957410,832441,879028,18077,704674,787123,784997,703031,529661,716299,13801,909981,207181,34879,600782,937726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]