SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324818 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324818 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137167,535136,958767,385241,103931,656189,891592,79264,20985,1002964,1036277,978476,1043414,908682,461657,240622,494746,126064,373914,875395,1039818,808980,703595,452482,352530,741049,867275,339870,965004,114037,111931,718801,722993,103718,1000993,395064,347363,568097,940033,298927,672282,240314,295343,156778,107960,914521,977401,682770,913486,302797,969323,48325,406303,795114,145667,935847,785490,650889,462356,534372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]