SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429270 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429270 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459344,13346,162136,264776,132751,369055,681208,252232,1010465,252742,601038,41494,185957,361125,44191,633137,157998,557590,178375,618388,863629,607031,935617,460428,572593,408278,557330,856123,552415,695417,427829,544800,502487,1024281,1029654,860347,1006981,937844,677816,324127,991978,528951,791709,454900,184930,798193,339173,411265,744515,685129,415829,240640,926524,1010760,490097,403280,384558,353723,39980,244051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]