SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47103 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47103 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329180,544980,1005445,533023,866911,255632,40296,935992,374992,85694,744707,602265,613968,158931,517654,978071,618278,464005,151799,861973,496422,578602,558014,957003,1032187,261233,841011,363539,453937,715711,461698,729984,980462,1019570,42570,814389,786705,905575,152085,606469,233143,662667,964621,1019636,912084,804634,106376,708045,196422,850194,849094,507551,601426,209858,273823,853778,161743,18872,678654,728647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]