SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354092 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354092 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269850,393825,220592,879612,1008336,377560,460224,975074,570824,220412,591866,1042301,245696,711012,577234,780109,1020805,421288,1039615,698490,772918,679991,675592,365450,223205,338548,964724,613450,146611,903021,433178,483616,759533,681251,579543,864745,728314,612873,899212,514494,575307,645801,480583,344221,582477,784077,1021,308079,74135,1033711,804857,1000653,1025321,437593,582378,11905,292449,893196,550917,211645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]