SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805346 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805346 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575117,14456,602991,877390,533701,976253,983173,490726,134710,5307,644375,31283,22407,601760,662678,698193,743106,375755,380707,5903,849640,700743,1046753,369113,733288,511935,815297,776662,196534,631170,928557,694143,505615,832523,11094,819063,268893,973151,757012,802154,707434,584621,962849,639832,1046675,55879,894172,450829,98901,888893,14333,100558,46926,902562,683202,190260,499967,369883,435856,964190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]