SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330417 LIMIT 1 [ RunTime:0.000745s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330417 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539502,118420,932972,388297,946723,669676,380301,1003693,181877,583024,106611,405187,201043,855190,1031815,102039,982336,172785,596319,623835,856323,901119,224644,829297,515732,27296,463689,830739,549503,499986,170586,955968,523900,701984,929571,811382,322746,255491,69619,499079,849636,44686,297270,454862,479411,751223,108346,330340,98252,858299,197724,783098,738884,849711,517621,1010600,817615,45368,108814,365283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]