SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98144 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98144 [ RunTime:0.004122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625867,317207,81218,100488,529399,15122,259412,783248,835356,61129,396878,568757,286502,748003,908493,478462,1045930,1031004,494727,74470,672157,567195,872115,753459,544066,723866,8140,395085,579757,234509,724677,363110,1044544,731830,186951,222214,333400,951446,773370,82690,738784,803050,153226,795243,342481,758364,101405,398830,381950,641084,1006654,176260,630275,465983,585205,716161,569002,271785,396789,434092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]