SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434267 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434267 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110649,554521,862439,541922,939810,265094,810590,462118,818371,926030,30969,807838,426134,165536,230596,646084,845480,790289,458438,408065,718402,913489,510723,245334,209468,577521,206947,883686,409104,420979,214890,574693,497943,972978,334954,476585,776251,100204,902954,7472,782691,592554,745308,160910,775270,376891,22079,490379,1012548,456264,804538,1037539,837258,903643,580776,668335,878335,156774,635357,886611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]