SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337023 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337023 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123460,428844,546327,226070,756650,204647,726268,337810,336340,1019785,29489,124332,304499,222835,888392,129096,899883,795688,867276,39063,500329,345456,486264,196239,385827,439291,613023,164330,677394,309673,910120,244929,248189,165278,1022345,560330,275454,764864,594469,272371,649553,129195,426833,351851,788463,466709,209495,807354,544750,66138,535021,909802,74380,408250,547503,587730,767348,540711,184585,299179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]