SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531990 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531990 [ RunTime:0.003536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553834,273548,561210,988741,667524,957232,981654,297391,84172,148698,282113,335516,910818,832255,40356,665172,108797,759394,534940,14925,655863,13918,196916,199682,1025795,508627,210854,797525,562955,135092,163516,856933,348098,389637,395078,451580,830690,55609,569216,716584,863163,4078,107225,581124,848485,288864,726795,363561,644009,696839,309261,423354,617313,392480,272952,241,466632,929390,859264,158043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]