SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479833 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479833 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110769,829709,506846,28141,21215,420544,762332,827831,733055,890195,180761,34407,350610,505709,108837,693075,755916,344683,459020,118505,730864,420712,686502,653025,768791,94159,551002,546485,503681,683493,70058,700341,592456,591129,1044476,650139,415356,409257,170349,793440,36504,142609,431119,820751,866947,933378,181964,509852,541746,175751,624086,268354,518168,949407,923723,388504,421526,28843,226921,1026443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000992s ]