SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040745 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040745 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480200,196805,606576,813134,160198,890465,350511,808029,588263,261458,404558,28733,193789,982047,98481,53819,929712,490735,810057,583467,976834,575621,320959,5745,997384,120000,482654,675779,300070,812242,542573,865643,94332,131746,601003,952581,503591,122384,844538,346543,13004,449778,479777,533218,772715,802070,755226,450095,580890,421572,796947,247428,513135,1032890,718207,196356,412199,291137,357268,464175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040745 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040745 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001414s ]