SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586328 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586328 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492173,725254,576476,396549,226506,565125,329988,46024,296496,343668,954982,575676,867297,236314,730917,132737,802594,1008045,295246,795702,424588,680672,58580,601905,308829,1017184,549649,798881,309879,930332,831881,520652,529321,978321,824240,729281,913873,641142,361389,790820,1021384,925165,650488,230818,9983,215745,681908,1011952,923818,1004638,812383,450452,538933,559497,400204,472772,407159,375717,338502,20110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]