SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566748 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566748 [ RunTime:0.003315s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917129,1003316,26538,770101,424399,629139,108486,591620,689971,1018680,646050,689174,1002517,289855,392314,384041,986875,831576,990229,793966,544577,536388,965873,124220,1027153,134401,623175,1003103,629123,503054,998605,547652,854006,941081,217762,105086,989883,589383,51954,18885,457379,944810,74389,980725,648898,460211,981643,620205,725296,1020523,139722,210722,524803,882570,203376,859190,800924,563720,264917,4601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]