SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483158 LIMIT 1 [ RunTime:0.002280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483158 [ RunTime:0.002368s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11648,183518,50836,388424,266232,626559,970650,235994,157426,872214,731477,187364,633088,145110,223380,228990,859064,758442,464369,57335,832468,1046920,154904,605562,1000287,757223,1044752,1035577,36779,433292,169054,777619,504295,907486,1011139,529460,849148,967238,629050,478992,558801,85180,453945,946759,795548,502615,402647,921590,208636,703111,363026,526678,423246,94118,1026086,289924,12629,685250,556860,1030839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002006s ]