SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44210 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44210 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467699,133605,346675,679499,541552,581259,239510,272453,143572,280410,291676,598628,145203,106106,433147,196639,367836,989123,338544,273029,1033699,943458,621815,436031,247694,573065,177824,677174,428953,485330,620512,621005,306181,622440,542172,80730,551295,731462,609826,567195,535513,311023,314674,223216,970960,651095,581447,544215,251099,145586,175383,659667,741960,173228,427961,522168,117462,205724,833132,380436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]