SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194081 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194081 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315586,777325,433315,90716,128430,771020,53492,315691,809631,406808,450815,1044622,142771,658346,546277,58344,266595,615321,68512,23811,17933,464290,586964,205610,341993,616039,932791,278063,155021,896593,350810,155601,542302,797237,535946,938986,971986,459157,64562,912480,130925,957652,838171,87581,367638,450641,987813,196637,891470,829025,955279,832509,582996,253843,346590,419109,104768,836383,329404,396011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002642s ]