SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291512 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291512 [ RunTime:0.003572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595906,814040,867145,394538,140164,106782,737852,935877,198667,664662,1008887,758933,137553,357087,564838,293074,392301,56634,466895,552418,383581,549533,898652,906769,103570,596642,798914,924961,63981,556748,578307,902345,242526,57209,969824,182370,399243,652340,86774,103223,794941,589485,40308,905289,748971,906917,666068,156297,766206,801338,58287,449569,371863,627504,425938,343958,135725,442040,265050,258978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]