SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39949 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39949 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822103,460669,894146,431611,828628,412169,761409,850393,750607,202451,661147,862940,582769,16871,592483,450380,252457,654320,885716,248926,810080,852575,656146,914050,762088,534885,401894,746553,864407,409995,3343,318497,806492,50794,135364,447996,141882,411241,498744,862111,782846,193757,32649,610499,602808,405645,515424,506851,897846,532510,696067,833019,760828,864794,853040,374570,756936,76117,566389,144089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39949 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39949 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]