SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501355 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501355 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764060,545969,707335,384311,676802,521879,348230,491925,123877,530047,897231,717366,507617,739660,1038310,900882,708249,1030404,203018,161081,725980,807840,522909,286317,530612,863946,251263,520621,498719,726810,771264,865206,791341,773057,602199,100634,563595,332483,727883,69440,147650,906084,700338,556010,582701,787109,262456,143152,712113,291355,285550,947689,55399,230271,402537,258707,165600,995447,313998,722353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501355 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501355 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]