SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014686 LIMIT 1 [ RunTime:0.001883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014686 [ RunTime:0.006703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984487,597838,261359,588335,657156,416646,194521,1023467,193436,875458,422931,841746,610368,724057,307392,409926,81148,575685,249468,500908,645887,176958,385976,251436,619349,375242,367689,103523,565420,634134,459446,87450,159005,929219,393775,729400,1006851,451769,909196,969741,1036538,184746,131935,633042,895757,101978,629354,122127,932765,665660,282408,822713,1040970,280252,163142,829367,260231,17350,680928,615460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]