SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455199 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455199 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597681,261843,888549,229735,214943,220902,735002,1038430,499136,1004726,162313,92091,409979,956067,1036512,477108,365031,989098,970503,195429,624133,612029,60275,499768,861593,936151,776347,1038023,364939,622359,346202,640988,162044,47874,58880,332968,366684,679138,733750,338942,847959,227039,76213,431081,1047230,1032327,798356,932686,992422,968618,464556,125327,842544,265544,1042684,421052,596680,706055,317268,506252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]