SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529429 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529429 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622254,723584,603035,11534,916091,1042381,244786,619053,743092,111066,1042203,914222,818116,878538,837111,565423,825009,511766,175807,527359,421036,75371,692969,963493,87542,469759,995367,713870,401983,697461,571073,726339,281830,44857,134477,782008,470524,687604,675390,933879,435343,67490,735370,500671,304060,805180,731384,296542,101865,707765,652739,164574,256831,931084,869109,104031,429956,973615,186094,652089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]