SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53460 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53460 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964806,372366,883766,751890,320391,933210,837844,291459,422862,1046686,774670,275310,309489,878605,221356,203570,644133,158696,675176,857898,117538,941002,94283,481550,949567,505090,228369,929166,74042,889616,1000942,929778,1033550,385546,411015,723201,979420,1008292,4429,651812,29562,189124,585861,198525,795746,703680,588524,1044649,942942,561274,122760,521028,559302,839932,948578,342139,119096,808938,864341,64743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]