SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 940080 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 940080 [ RunTime:0.001322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170995,215567,681694,767780,252403,662701,738157,951891,124834,219665,55140,290595,594031,100637,696852,382003,355203,117125,226874,460933,3688,608137,1003012,825730,582398,102815,326347,343438,61225,395320,192324,448272,1011936,69239,247695,507892,303452,288231,729018,12664,95034,681868,280987,596074,863714,8092,747724,963276,416037,892286,1015063,580687,76100,962388,621513,963372,631689,720105,144998,196916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 940080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 940080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]