SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433447 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433447 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381471,683843,527279,770032,693420,184929,579703,867417,512811,176474,977060,508694,374820,429685,110805,676029,690845,474394,466690,878003,943749,711313,482623,577858,497750,33265,689222,203962,454942,939377,685181,889498,4560,365751,204279,44314,787340,827180,375099,272776,813104,750385,381998,413523,140184,576056,808101,874112,563234,567580,683681,329642,661986,89066,144119,840556,84161,302731,750400,386640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]