SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483203 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483203 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37349,932243,124992,422414,131826,230430,840447,977612,184340,396848,319162,467264,550483,239305,520046,486870,269308,784355,385456,766151,564127,223974,30827,119001,891770,472637,989885,674827,693308,826613,620725,330921,140160,577457,758086,130694,878025,881585,488124,350804,807943,853172,412660,728241,112051,107030,607889,421070,527346,1047912,291591,662944,362795,827277,385011,139719,956026,883053,531165,445178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]