SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367830 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367830 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289140,977090,238834,510815,909044,477710,808964,891831,491545,211623,958378,402541,1010878,635993,652762,851916,877977,973364,890665,874746,935453,389289,408612,349430,567032,29229,374300,514770,897772,361602,968276,564604,222992,336620,908595,873049,598533,649616,533859,621884,121492,405305,805761,168804,381606,752133,373389,443707,948509,80339,719774,998794,559028,141638,959692,688457,305510,78803,56132,721236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]