SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570706 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570706 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376014,743919,246720,594816,894000,361200,760951,551520,998151,823629,536975,948116,825801,807312,229588,237394,920491,71152,384262,430808,550264,46858,557707,477896,784502,476001,797863,389932,379648,770565,992768,746427,538637,675836,488338,571913,986414,979369,676634,99554,428376,54228,1033056,53470,824049,198298,414130,326667,494816,788485,977974,117934,42522,105617,308772,1022409,187863,414906,80120,723798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]