SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357541 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357541 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314688,108504,162762,320225,301055,153714,747980,82249,630195,746247,950718,420006,1043058,813071,510640,451265,1022467,1038079,936087,341727,545620,466240,506856,515844,128604,68801,202926,255975,437561,987090,108911,396923,1033249,161485,533692,837344,232100,235202,878071,343607,507466,915156,262331,142666,320749,973203,848868,464618,980472,855451,886071,355190,385288,274735,734780,401363,911969,913634,1006096,1044036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]