SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017400 LIMIT 1 [ RunTime:0.002429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017400 [ RunTime:0.004226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811755,368215,188852,454702,93335,699384,549510,864474,347989,884465,453719,968025,347151,121617,872427,527155,266621,154981,562546,738253,323623,543413,827347,514949,413230,68010,126065,981791,296784,871923,131655,378282,529977,708246,442060,235530,670639,591115,727303,827114,615393,177625,64720,337379,755411,302049,810288,457395,705461,531756,553141,977695,577291,875689,652353,874063,39308,982008,715663,679628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]