SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022573 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022573 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816279,49850,366848,673880,425110,615057,109767,251430,212970,69870,195047,911963,853317,24536,40988,583406,204999,499467,305610,817852,751040,892484,576527,864365,437641,286971,679336,679990,967603,923035,170554,28840,583966,801064,43216,904296,938444,549932,662000,684710,992561,201390,876347,210910,530232,713751,750534,159825,933782,270044,186402,731355,415967,647602,990060,584507,121967,275204,866647,284838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]