SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265472 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265472 [ RunTime:0.002771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281311,887108,842393,947632,648300,187020,784522,490199,467648,802054,17502,832887,523338,1033861,156136,421348,1007538,475157,327812,122821,565873,714932,681437,640184,122809,1034593,246639,935803,566990,365368,283258,42844,356778,532062,74613,538912,944069,240288,561975,363398,698126,1024180,810100,201192,513790,1019046,996145,102430,810883,37174,513254,313088,856492,402778,810595,373725,749939,895474,753139,585653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265472 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265472 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]