SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102234 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102234 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861840,479133,371983,800877,139148,44672,278485,144394,915702,361824,182078,407939,892686,376255,636829,881990,217843,767130,618872,465299,600212,278232,836147,602231,352123,134153,445476,322860,671761,307425,399508,1007082,477619,853347,1010886,629627,342730,830955,768332,321771,297709,739840,800766,464587,753634,555516,585109,48530,426500,985469,536,210886,217054,773000,232879,847014,785868,708788,342840,160831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]