SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536806 LIMIT 1 [ RunTime:0.000953s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536806 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518765,736440,282772,370532,660169,738031,878427,403902,906700,811796,393863,696847,82183,891131,158456,480047,969514,489734,768131,182148,224317,977413,919374,822678,329643,408658,629932,386443,503468,628275,737719,554565,161870,500046,591054,434934,1011624,522018,890331,837676,888577,308720,26741,615604,38088,298776,820001,821058,20022,160345,397700,792583,548391,846682,630902,105711,532242,1048921,521708,217864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]