SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507678 LIMIT 1 [ RunTime:0.002280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507678 [ RunTime:0.002920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228242,146283,177067,880919,664304,330870,409112,103751,1035722,583596,660603,731450,875307,118678,597818,251242,120467,581482,1010197,758331,496428,260552,778136,232616,285665,228549,460551,571597,9038,440093,343126,93186,434452,137291,1047962,746692,276846,933825,823253,82097,1031566,872765,592635,478618,867056,150887,498558,433710,817760,28515,306270,1026507,153722,415450,414059,566453,772007,629836,649790,614039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]