SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003779s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047718 LIMIT 1 [ RunTime:0.002287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047718 [ RunTime:0.003213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716315,782272,590124,342442,641575,122693,301375,437490,499443,529460,1032240,571003,340074,130939,1047020,205295,729359,729541,213889,484451,485667,521597,291638,882286,981857,760604,307239,362009,358724,215046,720895,164559,225743,594838,217284,9870,803874,487003,334160,130397,517135,93221,693339,120647,864845,379240,47140,452735,682976,293216,395987,2982,33122,870388,776933,1038592,537276,304840,680168,741525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001843s ]