SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687418 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687418 [ RunTime:0.003279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791681,627159,381369,157228,436621,280707,478361,961793,439283,509624,964204,399129,602982,1044121,859529,428772,988396,951869,639129,386967,940634,893691,270079,637872,598570,951369,560664,890882,1018569,849468,272632,992992,893736,464996,48062,164243,472767,319619,1008991,343319,704650,138324,901338,513273,613342,1017580,216886,969417,675018,989689,857629,738964,141313,845047,756666,408764,679256,264761,986152,331501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001249s ]