SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006845s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803209 LIMIT 1 [ RunTime:0.001734s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803209 [ RunTime:0.002655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400832,767830,609214,742153,142409,131925,939938,893774,449623,716914,728145,919291,102017,719822,647431,465649,102985,333607,1029951,90803,586218,335422,575873,637357,919458,296106,159620,657822,556895,972887,847678,623111,527141,274838,489066,393580,154547,962970,259654,1020038,966083,462722,580710,1030048,747954,811486,225986,710522,615143,835639,39419,513230,787501,803197,660435,820243,724360,753652,403330,244873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]