SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406710 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406710 [ RunTime:0.002630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905561,1025556,722250,140117,809583,855278,335986,438436,819645,151691,178937,492270,944630,667388,1292,656614,755055,48050,745771,932223,207746,779179,590028,839008,805139,255238,248192,519187,780221,474740,679118,1006668,499899,1037981,497589,850941,378841,375410,365932,175991,95209,198004,497231,514905,375225,926822,425005,130789,52795,961734,468819,730870,462287,110602,81191,127178,499880,707915,1002383,603204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]