SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484704 LIMIT 1 [ RunTime:0.000621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484704 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131846,261864,21518,992671,411776,750244,780425,133502,564175,289320,48091,318425,505995,357262,104588,116815,539285,748541,755605,47442,931307,675277,537260,677705,98783,601714,313778,1045071,187652,274373,983301,213650,29084,297038,4368,793816,328264,281485,556684,462970,538415,765763,60286,81290,801439,748239,54503,101261,271513,157116,1011928,715116,427952,316377,583575,257121,880867,847247,590456,812044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]