SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034992 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034992 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201731,564372,189786,325343,321641,734096,887554,696394,108852,448883,274686,896607,173702,971453,10497,826427,503474,10213,7482,474696,976360,578530,497353,518521,551400,947783,831914,629298,950792,546835,323449,1017673,184580,490417,951075,230235,602012,60858,373881,70290,937765,163270,472438,58652,1004147,897146,838145,340227,551701,103093,140245,962773,329784,60107,330303,691862,276791,253565,995930,617329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]