SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304860 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304860 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245331,756292,317595,384529,818448,295294,864800,485002,754098,351092,308222,497060,417295,62966,624290,568345,150312,670359,625014,1032958,10623,391649,857004,166288,707380,308667,724978,784592,463253,817101,860231,566176,967170,562542,736305,732502,144892,125490,216614,948587,661583,609004,457304,537708,118559,428933,299594,192002,994677,867505,89309,1044686,959608,514062,491523,834688,907319,900705,874598,562720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]