SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024782 LIMIT 1 [ RunTime:0.005789s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024782 [ RunTime:0.006059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257803,1037641,677193,87280,983266,758781,959943,780189,116088,1009061,368001,667237,440589,67537,61210,885766,802006,986264,790045,552997,771618,550174,679346,746025,402429,639732,467332,709481,56882,468833,928735,992959,228636,570468,863020,923405,690943,932692,724213,797832,442563,720416,385002,774251,318251,607987,943875,592565,880354,475221,443202,175360,565063,724801,881043,136015,377758,963282,761804,435606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001311s ]