SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 214150 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 214150 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566740,1032966,647656,854996,1029939,241667,250406,189757,469498,532073,393410,392114,391246,872421,520499,179891,826098,32153,952681,369695,861936,522475,630326,747804,560703,429240,945974,195837,251539,822644,21799,512598,956761,210897,575704,608892,310395,246740,101777,27102,433169,347718,636497,190740,80063,268943,201908,105777,232860,927551,145693,707947,512526,445880,799437,428054,122427,785605,1011809,244664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 214150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 214150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]