SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983449 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983449 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342076,339120,1038080,474621,990425,206866,477858,150131,801839,348686,397040,49981,674769,859670,111947,485601,13006,933463,1045727,116422,56538,641300,443565,270298,941612,280587,452545,586006,278274,962903,531275,386575,1041464,1016659,587112,514692,508093,471721,685768,620767,1004926,13179,672504,878012,386023,320175,284364,816512,295160,1020072,1039456,14513,1363,1031687,756817,785050,148555,646406,727973,307923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001231s ]